package com.android.audyalarm;

import android.content.Context;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;

public class AudyAlarmDbOpenHelper extends SQLiteOpenHelper {

	public AudyAlarmDbOpenHelper(Context context) {
		super(context, "AudyAlarm.db", null, 1);
	}

	@Override
	public void onCreate(SQLiteDatabase db) {
		db.execSQL(
				"CREATE TABLE [playlist] (" +
				"[_id] INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL," +
				"[alarm_id] INTEGER NOT NULL," +
				"[file_path] TEXT NOT NULL," +
				"[add_time] DATETIME NOT NULL," +
				"[play_time] DATETIME);");
	}

	@Override
	public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {

	}

}
